Boomi for SAP walkthrough

Boomi for SAP enables you to ingest SAP data into Data Integration by defining SAP views and replicating them into your Target systems. You can perform historical migrations to keep your data pipelines synchronized.

Prerequisites

• An active Boomi for SAP account.
• Create and finalize the SAP views (the objects you want to replicate) in Boomi for SAP before connecting the Source.
• Ensure your SAP/Boomi user account can access the views you want to replicate.

important

Without Boomi access to create table services (schemas), you cannot extract data from Boomi for SAP.

Supported SAP data types

When ingesting SAP data, the following SAP datatypes are supported and mapped:

SAP Datatype	RDBMS Target Type	Notes
CHAR, VARCHAR, STRING, SSTRING	VARCHAR	Standard character mapping for text and strings.
NUMC	VARCHAR	Kept as String to preserve leading zeros (essential for SAP IDs).
DATS, DATE, DATP, DATL	DATE	Maps YYYYMMDD to native DATE (YYYY-MM-DD).
TIMS	TIME	Maps HHMMSS to native TIME (HH:MM:SS).
DATN, DTEL, DTEN, GTM1	DATETIME	Normalizes variable or human-readable formats to standard DATETIME.
UTCL, TIMESTAMP, SCTS, TSTMP	TIMESTAMP	Supports micro/nanosecond precision for high-resolution timestamps.
INT1, INT2, INT4, INT8	INTEGER	Standard integer types (SmallInt, Int, BigInt).
FLOAT, FLTP	FLOAT	Approximate numeric/scientific notation.
DEC, CURR, QUAN, BCD	DECIMAL	Fixed-point decimals; check scaling/precision for currency and quantity.
RAW, RAWSTRING, XSTRING	BINARY	Maps Byte/Hex strings to native Binary or Varbinary types.

Configuring Boomi for SAP integration

Step 1: Create views in Boomi for SAP

1. Log in to Boomi for SAP.
2. Create and finalize SAP views for each table or entity you want to ingest.
3. Verify that the views return the correct columns and data types.

Step 2: Create a connection in Data Integration

1. Log in to the Data Integration Console.
2. Click + Create River on the left-hand menu.
3. Select Source to Target River.
4. From the Source list, choose Boomi for SAP.
5. Under Set Up Data Source connection:
   • Choose an existing connection, or
   • Click New Connection to create a new one.
6. Click Test Connection to confirm connectivity.
7. Click Save.

Step 3: Select a Target

1. Under Selected Data Target, choose your Target system.
2. In Target Connection, select an existing connection or create a new one.
3. Click Test Connection to verify the Target connection.
4. In Data Loading Settings, provide the required details:
   • Database
   • Schema
5. Expand Advanced Settings to configure additional options. To learn more, refer to the Advanced settings topic.

Step 4: Configure the Schema

The schema configuration opens in Multi-table mode, which lets you replicate multiple SAP views.

note

Column names in the Schema tab and on the Target side are displayed with dashes (-) instead of dots (.), as they appear in Boomi for SAP, due to target system limitations.

At this stage, select the extraction method to use:

Standard Extraction

Standard Extraction is suitable for scheduled or periodic data loads.

Standard Extraction flow

1. In the Schema tab, select Standard Extraction.
2. In the left panel, search for Schemas (table services).
3. Select the tables or views you want to replicate.
4. For each selected table, configure the required options as described in Common table configuration.

Change Data Capture (CDC)

CDC provides near–real-time replication by capturing INSERT, UPDATE, and DELETE events from SAP.

Configure CDC migration

1. In the Schema tab, select CDC (Change Data Capture).
2. When prompted, configure Initial Migration Process – Default Settings:
   • Enable Initial Migration (recommended):
     Performs a one-time full load of historical data. Automatically disables after the River runs successfully.
   • Skip Initial Migration:
     Skips historical data and captures only new changes going forward.
3. Click Continue.

Select tables for CDC

1. Select the SAP tables or views to replicate.
2. For each selected table, configure the required options as described in Common table configuration.

Common table configuration

note

Applies to both Standard Extraction and CDC.

For each table, you can configure the following settings:

1. Click Mapping to review and manage column mappings, including data types, modes, and keys. Options include All Columns, Match Key, and Cluster.

2. Click Table Source Settings to define how to extract data.

   • Extraction Method: Choose Incremental (recommended for large tables) or All (full extraction).
   Incremental extraction

   When Incremental is selected as the extraction method, you must choose an Incremental Field. This is the column used to determine which rows are new since the previous run. During every River execution, the latest stored value of this field is compared against the incoming dataset, ensuring that only new or updated records are extracted rather than reloading the entire table.

   Supported incremental field types include:

   • Timestamp: for Date/Datetime values (recommended for SAP Date and Datetime fields)
   • Epoch: for Unix timestamp numeric values
   • Running Number: for incremental numeric fields such as counters or sequence IDs

   After selecting the Incremental Field, configure the Start Value to define the starting point of extraction, and optionally configure an End Value to define the upper boundary. If the End Value is not set manually, the River automatically uses the run time of each execution as the end of the incremental window.

   • Filters: Restrict rows during extraction. For each filter, specify a column, an operator such as equals, not equals, greater than, or less than, and a value.
   • Click Table Target Settings to configure how the data loads into the Target.

3. Click Table Definitions to define an Advanced Target Definitions.

   • Table Prefix (optional): Add a prefix to Target table names.
   • Default Loading Mode: Choose how data is loaded. If no key columns are defined, Append Only is applied by default.
   • Upsert Merge: Inserts new rows and updates existing rows based on key columns.
   • Merge Method: Select how updates process. For example, Switch - Merge.
   • Filter Logical Key Duplication Between Files: Optionally filter out duplicates in the Source that should not appear in the Target. Use this only when duplicates are expected in the Source but not in the destination table.
   • Click Apply Changes to save your configuration.

4. Click Bulk Actions to apply settings to multiple tables at once. You can:

   • Select Tables: Choose specific tables, tables by condition, all tables in a schema, or all tables.
   • Bulk Actions: Configure extraction and loading modes, and add calculated columns (+ Add).
   • Summary & Confirmation: Review your selections and click Apply Bulk Action.

5. Click Reload Metadata to refresh and load the latest version of the available schemas and tables.

Step 5: Schedule and settings

Scheduling the River

1. Toggle Schedule River on to run the River automatically.
2. Set the run frequency and time.

Configuring time-outs

• Define how long the River should run before timing out. For example, twelve hours.

Configuring notifications (optional)

1. Add email addresses to receive alerts.
2. Toggle the type of notifications you want to enable:
   • Failure
   • Warning
   • Run Threshold

Adding River information

1. Enter a River Name.
2. Select a Group.
3. (Optional) Add a Description for the River.

Saving and activating

1. Click Activate to finalize and enable the River.
2. Or choose Save & Exit to save without running.

Troubleshooting

• No views listed: Reload metadata after creating and finalizing views in Boomi for SAP.
• Invalid filter: Verify that the column supports filtering and that the filter value matches the correct data type.
• Schema drift: Reload metadata and rerun the River to sync updated structures.